SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043284 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043284 [ RunTime:0.005420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499922,695429,595659,14651,801829,584793,468269,314655,751796,893466,481580,220619,258342,291869,835119,636414,1037252,668958,352499,713923,369397,1026190,162690,500756,21421,860905,300872,1001582,353206,433043,179956,947183,92122,21583,402680,430794,25058,48724,750862,722911,427271,225193,267822,405586,526848,795889,985123,274838,87633,945780,15087,664731,466616,551719,1003505,370664,982863,438172,939134,759622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001096s ]