SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567510 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567510 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612198,206684,729815,173240,274258,425034,1043357,337998,12436,772614,215646,786634,973379,425636,108247,459617,241771,262263,1042473,654877,1004636,1043914,986750,511619,242422,982254,347661,308411,67219,755733,929867,706882,933809,196821,317224,935248,346638,80563,274145,968725,355359,836072,451651,108165,299509,659107,28157,105787,658492,173128,369387,926739,947511,808557,262105,998257,429371,460694,16176,1039874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001736s ]