SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53572 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53572 [ RunTime:0.003566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415183,150490,473749,225526,460142,784290,161469,173033,874297,188996,167574,550476,978926,612883,22967,157809,231633,360479,242265,546586,667821,696573,632397,664708,618783,619285,624231,905048,133324,474976,765351,664543,303053,628899,929302,753122,193199,791931,39893,339321,534990,618203,784503,657128,410899,613703,264786,574585,608644,1016399,563006,266299,377194,601643,712076,818031,209330,328452,413079,115785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005265s ]