SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662015 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662015 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544676,774963,983257,340018,522721,602790,384671,552756,221643,434584,463760,416309,726283,727393,329797,927377,485035,830786,368295,753159,624030,466480,555806,85977,875595,262022,584167,448731,669692,193644,956655,241201,326507,1002022,565924,802218,370563,1040375,841555,1013688,62747,599357,741712,892945,530421,775006,50912,182517,783833,127720,505697,270859,159049,438516,295137,901672,289858,652447,504383,710924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]