SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437781 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437781 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024034,180591,915599,293126,457267,434293,536109,242576,733189,173442,814382,171727,478230,939601,616284,972157,892776,103334,842428,278413,566949,721625,564042,360784,287176,50072,142644,121684,398188,1030707,378566,702298,234924,1024286,976640,809321,469113,722954,61222,380914,199834,682818,472443,786811,917867,746735,986776,774292,677582,1003394,1034223,709644,396968,862376,840381,729171,720973,679264,424420,9568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]