SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502361 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502361 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982614,501327,26324,650882,507380,235307,617813,629845,795619,726875,773897,280302,153174,507976,593604,553224,933710,583958,407517,438028,135761,523822,514552,852668,958064,126686,228597,883308,780754,620061,610765,332960,475276,1034948,889540,275033,220714,1006427,191133,226148,944276,186476,469869,369295,119847,486220,193205,21660,330979,761298,790709,856602,10034,949750,760382,345233,110893,900093,906700,382917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502361 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502361 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]