SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100571 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100571 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136337,273710,929756,949469,283589,575719,758092,409914,356928,610425,423210,41602,571063,133705,693863,194125,9214,489928,18314,156183,190907,626657,557548,549401,235294,127122,685896,404679,257277,539082,576181,245199,934895,955182,688681,591580,503285,107500,429198,625070,27109,576518,659576,745363,439765,507248,39645,1043724,851706,943875,82766,119061,626771,775968,369913,257279,372128,400510,23611,18820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]