SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287517 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287517 [ RunTime:0.006536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541417,200525,320778,945769,344043,375952,366839,972530,640686,424624,1033162,907738,638722,283412,1021891,599714,36780,735413,301118,1043815,1015076,276908,1004604,492912,565990,27419,937991,940164,126038,889388,768537,193617,972604,445952,787401,776524,933278,41593,371874,127586,694647,57707,790149,843767,67677,813632,232391,946970,338946,288373,392362,46964,581630,420358,323219,445120,809254,559054,134569,564014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]