SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522614 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522614 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (870112,473312,674347,850234,991485,981043,181661,266733,708309,261417,182534,241123,220102,173849,11322,766632,19955,875172,450301,23183,802712,615526,835424,135885,960859,878265,148665,710531,157672,523293,544610,224022,1019175,333623,66783,624130,500968,22392,542484,559897,962179,492742,582815,102526,395926,12540,276115,542521,1015179,939103,611470,909527,123662,976096,943538,61890,292264,14901,828544,529098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]