SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414569 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414569 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381972,1021356,676446,188614,237312,685218,581076,181373,883453,20136,11061,988983,767557,91458,375061,233133,20934,776328,902145,123847,283796,949073,457734,493041,1042285,510679,205839,576910,687291,38252,932167,4125,910998,859178,876015,962824,269029,438400,655372,242867,191566,499859,775062,1013616,540133,1025071,336094,668184,751318,800215,985487,499636,909019,462009,648009,590949,709885,968318,466963,525103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]