SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535928 LIMIT 1 [ RunTime:0.001612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535928 [ RunTime:0.002790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755435,715450,435446,583247,168724,469487,359566,940519,311234,469544,755676,540345,272618,189114,1036824,372171,645605,860696,672578,397718,168386,163169,749017,502321,58339,584410,224581,857139,984323,225636,943964,368578,747325,897119,503166,810001,64406,378146,540947,611533,466125,632354,1029528,208045,328808,982268,123417,746974,658050,842979,574095,268918,971771,433289,340602,378199,108709,448196,236436,267631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]