SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980315 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980315 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987999,821642,613737,543411,595731,137077,725674,280510,145776,690385,98816,717245,172634,609274,842632,570724,1023651,367873,869236,475390,550254,653764,401666,201684,415052,95567,441876,1020679,867240,1033261,978297,943398,131019,645731,152386,211136,228350,272595,552234,759798,581948,106118,973599,771469,712399,1044711,285906,947161,414639,319048,226336,231138,171811,732104,421037,163834,747727,962072,210113,618849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]