SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538416 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538416 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463668,264578,599073,528303,923468,64071,460207,852859,218370,751577,1026315,1022236,844631,173724,916757,79330,421334,137453,337238,244468,503186,835675,438172,685325,759547,926638,133357,714594,332201,658965,147956,477457,966725,350795,499138,2674,411927,99193,580260,633806,549829,214564,200828,154727,46784,932261,434117,1003,525383,169841,550253,831300,14241,313886,629106,93259,136975,495943,1031344,358875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004304s ]