SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464252 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464252 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888294,472930,102138,142700,610726,179018,224107,115888,241910,804517,974477,276234,183981,998799,832332,399583,142149,925899,1040601,1030402,134952,455457,192515,1006226,1011505,176678,722019,459063,219792,781662,12741,498655,768824,397712,980549,665034,439588,107362,121780,148018,647681,836990,792936,916628,440461,588879,286922,955754,625342,825978,868130,851996,593734,196137,501550,107490,332765,732628,389917,387496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001450s ]