SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503061 LIMIT 1 [ RunTime:0.002358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503061 [ RunTime:0.003451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51863,273470,213928,286718,885006,985462,628198,649250,436303,358860,447487,640866,179782,536656,314913,499126,674993,631034,799800,1043347,672329,941625,292135,896510,245111,456395,703787,743927,408108,382835,1005482,632933,790940,1019742,347647,378637,864012,1015023,760683,825600,1014698,686812,391174,257209,606875,921151,565104,53720,319716,629000,599477,669216,993342,19263,342442,213106,633491,215058,899101,547371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]