SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547535 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547535 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868395,648929,560223,806670,340956,422221,54723,204688,901851,473123,229157,139830,16037,115188,1035712,201338,473942,506936,765942,569356,545175,315105,372209,235003,133223,99908,1009514,462649,673579,1028022,437627,130517,101190,68133,699664,318991,488714,528311,102722,946771,51622,822799,142648,623989,500100,980678,154804,15310,46574,235245,415219,513761,354555,993011,316734,432387,9721,306405,200084,200473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]