SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382558 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382558 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180690,906678,508259,311522,144560,188097,538004,349600,1046661,835623,539128,540739,47062,992635,641812,42243,786609,477860,295167,1032673,343460,8737,214591,855278,93583,671164,276528,256541,92420,110980,280395,204335,29446,484267,843456,170380,391599,511020,226946,769377,877950,89147,762830,77383,192439,607337,665879,358610,248651,600041,997161,685491,718642,51855,325356,66474,762033,745176,684480,932639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]