SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102196 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102196 [ RunTime:0.007477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237950,1002532,919031,329574,842050,455760,242548,824529,954410,924750,963809,5276,1044520,298516,949902,245922,968693,34214,770862,155387,698112,317898,575178,820849,887222,1029586,596270,159161,14178,211913,248666,483137,22850,1007356,129240,69968,395586,11560,969913,1034371,380550,400091,200745,645764,1022183,912221,354800,694601,940280,176301,983161,170959,727808,614239,811972,277221,123645,726744,572847,564095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]