SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194362 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194362 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283218,103634,786284,800829,354543,347541,313340,296723,152804,486218,606316,376546,495912,240654,1045788,277100,470645,915990,415872,602809,286755,591222,954904,826936,78808,461060,343836,264391,518863,1043736,998011,366108,306278,441688,849005,703005,633938,945729,637319,656286,96572,304369,657167,390505,998498,430120,106075,527882,670784,1004205,466749,386357,387589,790386,920492,390694,185055,236608,805744,400949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]