SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808028 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808028 [ RunTime:0.003618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005452,502965,652593,694893,311660,542117,859614,58048,536745,587827,9183,658708,1009045,429457,171538,771110,523315,733924,789152,111462,373091,357919,1007023,278439,69312,45859,224595,731053,484914,714492,616872,119581,212984,838515,745266,976496,443230,864493,861044,709707,122240,564459,218326,571442,655140,424836,174232,670980,1017458,667705,366379,1006804,1012024,614675,15858,224640,661702,144316,407838,185894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]