SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405280 LIMIT 1 [ RunTime:0.002227s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405280 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376404,137066,713317,888993,586425,650193,316035,782179,581943,456225,667456,934588,517191,59953,466178,205509,221010,97761,333490,444854,910157,512495,580398,1014560,132760,407886,608202,402956,686789,782778,109776,377106,427217,664728,893317,825690,920017,672935,576604,822300,311601,268114,188525,148060,387036,791062,90143,50872,424690,667922,215032,914787,899523,939063,345688,346119,69057,102680,914426,389461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]