SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822101 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822101 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617839,380748,881810,418845,114836,433642,802662,1010096,85251,761962,637088,404185,644606,896234,648632,472442,611542,194048,883317,193146,494401,662259,463221,595639,704736,773799,692423,463326,583007,437640,694966,218072,1010640,484037,380757,961997,260719,395804,628170,875861,35837,63858,645968,456604,705965,216711,903062,307679,269864,747636,351975,274034,297027,443385,1003970,851655,635265,398058,847324,539338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]