SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451903 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451903 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129835,523380,727011,304153,854831,37059,472117,583927,414711,203328,1041832,143729,908813,996968,621985,772691,867936,451005,1025332,519728,472858,644967,246267,753089,796713,916878,562164,353180,498346,551090,384004,78768,1033602,643100,887226,669787,332048,958519,419742,982857,1020454,425135,2893,64925,791677,427480,93751,303848,304393,173741,800713,485097,1046301,920443,23734,443749,599879,980827,632131,660057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]