SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004036 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004036 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198916,380721,38366,757447,608673,890895,502239,742370,478312,828056,448024,46716,569417,358963,849670,57867,666231,218623,1021686,393255,293140,743286,764078,256912,694066,212440,206917,730998,102452,20359,541467,922722,413688,976579,263275,974047,820148,874237,506799,842703,992958,1029742,465418,634543,986006,578658,182160,1025453,187259,836,311277,996254,921882,502123,954920,415703,970864,903172,1047509,896217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]