SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501356 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501356 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132584,1048871,379550,70530,914051,914333,453715,638265,171405,1010098,849572,559179,441430,491171,859479,719942,720793,512150,201938,12910,553496,196894,624523,765507,395004,507216,590772,21237,657819,872518,581158,905894,47269,954491,332607,485422,808518,889924,52959,323198,41474,653494,521048,465186,800350,296712,340910,217785,707822,367404,568675,666563,240868,256605,68325,261316,490734,628525,411211,711522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501356 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501356 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]