SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30910 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30910 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266015,21241,937718,457373,462595,712224,760349,196128,540677,1012296,1044543,531926,336955,405904,400144,170255,666563,250731,712016,329843,909192,381178,743047,508298,986762,559028,624484,774093,566456,416444,171697,392098,620306,675171,6585,611028,548390,823248,526466,267698,6384,1010560,253998,720900,821780,886418,420566,520433,725102,1042912,581138,875830,261320,1022234,175947,577516,906021,855130,568880,425465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]