SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523101 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523101 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81246,409505,32418,96827,1047139,22449,285738,528006,769143,303977,232276,796543,699177,723203,218900,165548,1019369,469658,716777,41311,882088,295999,636210,622494,689531,830665,157120,700581,404518,1023371,1038370,625935,994691,326950,692763,146780,598528,823524,317498,437249,327576,196485,774952,247350,777651,291917,512579,184050,398929,1021277,1034655,341029,549742,1045495,637961,494387,52693,335474,774450,145272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]