SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415144 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415144 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917891,376689,701887,270210,609735,407280,906877,528273,331938,182527,372301,82273,312489,403424,960686,788459,805347,495439,399574,875972,205604,107244,415794,177224,668279,574061,881492,865814,252680,858784,519070,122227,447589,468118,303614,38509,203399,1024340,46753,356367,56143,512644,258590,380151,169573,377444,895916,867762,167310,502455,466245,47993,331577,89080,813162,3725,799234,307857,458289,389193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]