SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029967 LIMIT 1 [ RunTime:0.001628s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029967 [ RunTime:0.004598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978967,424112,1037252,724352,1028957,1028452,642321,417657,45519,780964,525554,72286,303906,818073,854516,201418,287987,876784,36076,212800,42284,655175,712999,94545,721907,298617,8994,942299,890567,566237,940830,713486,739291,994797,939251,675254,389020,591842,1046997,67005,964552,459821,348858,232797,598127,383021,404160,35543,300669,718955,127680,386792,387371,487552,295276,852061,168171,316015,325325,719119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003245s ]