SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961712 LIMIT 1 [ RunTime:0.002089s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961712 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147141,861029,260510,243618,150897,559004,1008298,531746,387725,44245,194178,642994,375207,761862,160583,81276,965763,152471,929282,762175,164740,522550,521519,499610,536976,445713,45706,694731,707913,271894,939373,699439,895695,363637,768558,478291,8671,729454,550645,848354,322396,395188,489183,485557,906297,440018,114689,719,771392,431142,938543,946270,10300,732950,482149,141133,840536,96368,342389,912588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.025947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]