SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266501 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266501 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336073,122426,90590,382191,197748,325988,933996,460607,751667,204774,144531,865545,934196,915115,55597,384232,242259,243145,779332,155112,185834,341639,840908,989443,665584,1039397,497460,860790,263330,767148,733780,775360,186575,521183,1031294,658769,919274,851851,857508,810398,381267,540127,946369,296051,998267,542343,807419,270863,888082,801314,336824,963593,601666,164706,376504,405999,1035736,18913,986340,500002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]