SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240013 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240013 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542749,658637,137364,199401,813328,233930,72665,859189,657208,796302,712011,178532,809528,271301,725889,968141,315017,932971,116592,868554,924473,387504,646858,890937,773114,489158,816885,810160,938504,719513,779135,981758,142468,199064,427657,60849,1006134,677631,931575,441839,981181,440878,631177,177254,736961,419932,872761,687999,672115,200777,105687,350992,951287,449272,650208,831606,288776,245674,942473,867000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000368s ]