SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320585 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320585 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610616,203887,288108,541032,96168,100256,653524,541038,178283,528708,341087,40197,278946,667053,699677,385948,881609,967032,216610,614692,920556,901070,113397,872283,15655,757131,2316,585228,827454,283417,79997,834996,705204,320780,89123,407970,429789,199991,541900,288774,869623,566546,79552,994346,358908,509133,200474,464671,268854,977715,787071,176779,613191,250263,294483,67221,394057,877765,133126,803837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]