SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501060 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501060 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370038,903040,122445,677726,715404,1007953,809887,917642,212551,1020630,858148,191246,414887,256776,562740,383908,351629,915878,121789,274437,681108,924382,360768,43331,653471,163207,547193,83819,212405,248995,880096,520451,935977,43896,508693,784846,604858,825051,387618,393852,209164,285326,78224,676849,896332,993996,231427,1032626,698915,417350,686738,404237,301013,595125,656198,804619,32235,563669,813621,500420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]