SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49438 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49438 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783748,245685,912292,345258,750294,797547,600772,113558,282953,364564,53795,1015769,359732,566295,110314,223628,971314,801746,1046738,991321,993201,210006,438571,1048685,492915,297045,287155,641401,700361,337548,261564,462322,1003687,359530,787291,825741,441330,951621,235557,990474,248716,223402,255087,117467,647936,840504,259226,684200,312156,423546,473859,132801,814277,12367,859764,266379,993199,1036054,733391,156763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]