SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316584 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316584 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281602,979415,923133,210015,118345,989142,216461,347760,595456,795741,155123,1015091,1039404,171817,928899,543631,57176,53190,1025120,666380,680502,909497,132765,559238,901490,786734,580208,186098,948590,997082,375094,650545,541320,971867,453806,235372,438046,877760,918498,762242,111897,557583,626852,88524,941612,177074,286164,711914,235888,273137,574401,526158,670635,29675,121624,628491,868419,7084,924007,1023859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001217s ]