SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294381 LIMIT 1 [ RunTime:0.001365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294381 [ RunTime:0.002715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162543,718216,651325,65170,611030,906549,773774,351260,373109,39440,475614,446512,256327,219064,993726,379066,737928,112980,62329,537734,598808,334426,539685,727664,741684,744971,676095,885333,569224,851448,980725,630481,305124,823544,932677,538013,660590,1034614,806725,752396,499415,969466,836115,128669,1044525,707736,156731,525612,692114,640425,934265,508094,1003030,156956,723063,43505,84770,935761,296323,42322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]