SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362007 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362007 [ RunTime:0.003551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732931,426760,1022881,138071,994234,486180,959762,856039,89962,180924,44141,370729,530896,240684,607062,741961,28811,358791,742395,573732,299535,357921,496798,269002,21076,723294,327734,131478,63050,46903,783639,89889,432790,1026269,824547,755321,72442,200383,132913,238408,108139,431547,336967,963858,239141,565101,840051,440942,523433,469862,782477,348076,580324,378800,348470,612796,242021,909376,772783,430644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]