SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499615 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499615 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445272,678347,896586,361946,767358,926345,49301,1010729,363130,266413,123761,905269,358481,324536,746758,399647,922282,182021,450090,577606,758816,285705,648019,57176,86833,613762,592364,221774,365212,492246,415407,825218,893747,252755,694550,104113,926150,384505,576520,145973,30184,750351,259233,276364,711565,736203,561234,735377,425878,436169,152741,900521,641922,1037854,855372,915928,743318,95377,820854,407090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]