SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101258 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101258 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874383,491366,151556,587933,512188,693475,997818,658450,648745,808692,341408,272252,947856,691884,311680,659908,736404,598643,897729,642334,868461,165130,28471,959997,106972,78365,542286,209807,512877,707674,779007,121159,987587,765402,611594,732933,592721,809313,380600,37396,97086,227533,1591,624774,186888,238512,602000,544769,171049,882374,378662,799896,342161,341103,1037029,1042884,904055,541228,498256,505183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]