SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 188066 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 188066 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31252,538580,198117,879402,552879,1005061,891402,651253,288160,390856,108090,748552,453020,707318,525006,52404,232355,822201,685450,157230,143147,542770,112680,522780,896830,845041,850781,236754,552723,980651,13397,802951,135637,267528,471605,558087,364414,768477,476020,103933,902144,115007,1041143,929231,319653,570601,908201,1004248,185616,5507,983654,82503,83726,1042196,779553,514033,245783,593384,695850,978488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 188066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 188066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]