SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312718 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312718 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467444,25074,140088,32927,415390,973789,128860,50084,149893,9963,496207,1025853,693166,42727,768257,201073,817525,130396,318053,705020,869370,422251,929020,232987,190245,184090,674432,78563,428420,846882,134225,327742,431810,562769,515984,615508,428750,649786,280748,178823,347790,124863,802278,804452,356606,352752,105235,812132,118333,320975,60396,77418,689500,254793,913697,188796,944097,561772,842656,224366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]