SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567207 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567207 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963938,994021,185812,1019077,52792,263387,861233,116159,784699,136994,930670,353591,129427,450575,721540,640452,584127,141566,649386,222671,554910,496093,748201,262224,631586,272178,906414,360351,835585,351982,85662,609786,374692,440178,632739,393988,89199,344253,478311,562863,1014452,244464,423278,118202,454053,805929,553606,948912,431924,505306,336127,571252,551846,839651,474171,698049,1000952,524637,901034,426308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]