SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290018 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290018 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529550,94380,760150,624047,910923,387754,320105,823922,150788,463893,906479,675918,1022566,219727,464319,850569,292756,662234,286134,249940,199997,91610,337172,382954,478977,707053,495093,320576,1032001,360106,847493,170454,325265,365871,551090,326111,479355,38993,492991,380579,76872,848708,830051,1024841,167753,64472,523508,607984,992732,175812,153694,395777,492211,535539,924068,775153,196342,398140,350234,474034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]