SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525922 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525922 [ RunTime:0.003783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604699,325119,279636,918820,139350,680111,131941,8169,375239,125154,248004,347250,1002816,325777,90161,79742,230936,732250,848583,208927,806377,404829,551651,114603,993931,800149,775176,442122,273826,961515,331480,412179,42130,753827,76041,623840,970153,164569,403572,174469,650369,40074,1009405,829383,32461,127485,505853,398301,478092,436411,848393,816325,495189,665959,94861,479193,744704,945326,292772,36766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]