SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048803 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048803 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153702,611287,969991,501910,349212,227232,361495,457648,532204,772612,10462,780470,248176,977890,139908,642169,718529,64845,357041,589265,584424,805392,688797,23010,99986,871855,38243,697413,95983,664607,1046376,558679,697168,385546,443415,423360,729544,856256,785534,921417,33235,168947,397563,493772,157425,934454,458263,652830,516850,534221,130435,552025,158126,563668,91404,413251,971653,590969,478979,279372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]