SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399845 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399845 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151147,1020892,771306,407911,1038741,1015062,293230,494243,653074,160536,574676,42675,954255,760856,688959,440808,68971,936202,842452,56723,442463,816204,958104,290679,468185,202410,445723,533147,227834,500738,359783,531261,475281,164959,1040932,606223,508589,433279,706175,814324,657714,777479,326396,493040,168376,402450,991767,281372,54436,257746,671984,34839,439561,734916,491476,556577,836715,441251,562689,750523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]