SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341403 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341403 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887055,952943,39261,374570,360408,627544,897620,1020876,346675,172458,1022068,775400,315936,204641,820079,56679,150841,625923,602232,746959,358237,530408,467749,1036645,883101,831457,655844,602780,955996,217750,492670,159360,998522,411203,28416,551837,165150,160550,633082,799430,44906,47364,943295,785365,679271,812244,331615,818100,468584,684122,870878,995487,1010619,41361,1044503,583174,875566,936217,459404,859738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001383s ]