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` = 991428 LIMIT 1 [ RunTime:0.001193s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991428 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830078,663225,598792,30286,294731,76152,510283,216805,818447,331285,489295,821341,315225,311063,202154,935606,408179,508321,326477,292701,479586,496805,414039,933694,699230,345870,461676,684016,1036911,587704,86813,613361,495208,283831,335571,765837,810568,745056,534306,484371,747417,18486,376523,876047,346216,343405,672016,486994,1046289,926756,831951,425205,16141,906003,923716,926605,123819,427565,501778,379034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002303s ]