SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30179 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30179 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465124,404579,911201,142796,825372,456891,903289,169584,172313,801807,553270,579110,57045,840741,602666,870218,693428,342301,354187,851933,1034124,466009,787974,981281,338791,147015,331290,340924,407222,554155,621888,14306,379743,798808,875227,725115,886564,717195,321070,63913,344768,827482,433181,344247,80907,866824,264893,684462,699204,491254,78604,262137,344742,726069,705701,1046488,128748,666268,940985,828286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]