SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473308 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473308 [ RunTime:0.003011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108861,295381,667120,358469,361065,820445,21477,253017,18294,900074,81615,499000,802975,709473,849199,1025850,34776,289556,331031,847134,583998,42638,478256,810465,38269,894235,218153,15699,331196,595496,178866,336572,80268,429660,223302,501152,231396,850797,396607,37478,333661,838765,749643,1044280,337574,727159,219549,318472,87213,801699,345605,415721,498729,98162,815549,444856,747195,307382,28408,786828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]