SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201121 LIMIT 1 [ RunTime:0.001907s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201121 [ RunTime:0.007371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937329,540386,682418,868978,495266,632440,877993,425698,338569,1022778,144308,901586,330045,312977,175515,835157,1003627,447294,638976,835429,955639,436552,859553,729262,474453,588957,706123,221256,178742,35065,528475,722192,728023,43298,855267,890741,573734,448588,840093,462999,44948,303435,426604,997586,264069,75767,658026,308965,126085,762150,229632,446471,533075,280331,851382,197225,424642,176100,487981,84042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]