SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522002 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522002 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562129,928300,385505,956443,661810,314016,959423,267509,44552,841111,886004,65714,1047610,647116,367189,121411,843533,863958,1006433,724679,392926,639753,538786,884086,935369,669470,258419,34444,66930,159367,536049,464853,903119,807153,742204,648884,490417,1005703,181999,187683,870109,177706,170978,80359,926326,192175,387988,69602,168362,678891,795799,941740,154159,78456,422573,580633,956463,743375,110861,112160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]