SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804362 LIMIT 1 [ RunTime:0.000979s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804362 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62583,806184,747014,1047193,382082,987564,282441,185034,630330,604475,817236,800712,571769,351000,484002,171154,497986,749151,320737,692887,35707,525074,934837,511787,921928,200027,5938,336120,479656,979389,693160,466269,95540,264547,338632,837950,86941,929042,225572,467322,293810,95997,582075,929828,55709,662180,520708,19717,378568,829147,492111,334537,111114,843273,40952,676548,420181,196945,292154,430318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]