SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585940 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585940 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621640,56978,87120,889321,119006,528776,426734,1030042,365338,584257,625923,565409,227318,1023394,708150,721882,493873,678673,206409,596765,941250,1008093,156333,817386,637527,157026,104161,726951,971122,52928,474501,1039161,72876,439257,390157,419323,649339,622651,756955,795179,301240,621243,638351,748777,618622,728611,201704,206977,755490,542586,48256,654865,531665,216236,621160,26385,727961,445683,817765,910264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]