SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505876 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505876 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79893,353514,10402,495368,136822,639961,1000478,907093,470425,31190,782450,753625,189563,455532,201544,1033738,456481,323557,847535,886240,727249,336783,600358,111344,502097,6624,33295,168741,529108,18618,508514,642751,126604,680362,857784,168148,570485,929569,30211,480197,995930,639927,140150,853365,255137,312330,314894,487398,90167,371852,295079,817248,1001021,65722,108508,544411,670659,668742,215672,42299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]