SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413796 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413796 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958644,146899,251010,363246,936089,136711,30275,175245,337530,590577,298376,682064,258892,1037320,812008,591985,341616,33002,885558,581958,925305,91340,74023,740974,990566,1017287,251317,497236,705123,453677,287405,382347,887856,612437,570165,530812,399515,4706,887768,313540,379285,891126,1940,684687,399306,651419,895704,282888,326777,949504,860989,890954,980134,515926,477512,963946,904400,690741,763827,1015690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]