SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518151 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518151 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215726,333651,368199,1001601,554737,994068,519991,148051,602879,117437,182668,291811,1044301,89764,391371,568513,724551,514242,737524,732993,516440,14172,343047,1023679,472005,567290,159065,848459,596821,486734,757685,151140,184971,516725,500454,71293,479556,130534,1044978,181211,961383,1029916,914971,762548,941454,387654,1006599,869319,753986,972376,785217,631156,558818,546823,906797,313788,366680,154582,809238,298357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]