SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454327 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454327 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512470,441482,127430,131773,355784,665913,12366,858038,207807,562374,540249,372821,1023029,866899,889259,509917,1025931,571577,816999,274453,237750,961554,977088,781052,140775,558793,981422,427731,824109,835862,618005,393690,340009,773078,722045,415725,77527,278871,145459,374658,171352,342241,255821,302821,459969,686962,155632,158466,814283,769415,308286,28977,864813,884172,416383,911124,342531,673345,446150,197257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]