SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048288 LIMIT 1 [ RunTime:0.003702s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048288 [ RunTime:0.004037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984929,675872,311418,995565,494418,173011,244593,67786,581916,361730,11212,468011,635434,1003707,807454,616365,639926,104844,426268,895684,768369,866825,616698,956404,227078,95318,230769,858022,226514,678664,115228,655908,47539,36091,732040,366144,109444,387134,125286,839939,721500,249619,1037519,738820,260050,24331,724931,843757,490201,892668,400055,770571,773453,521928,208223,452965,303592,457857,975683,271086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]