SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544047 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544047 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911503,688036,285641,55375,763175,126452,254581,923630,724061,111324,335411,885078,368878,592014,463946,776721,889983,849995,1046612,552622,73932,449396,560932,761390,665375,25156,478298,962694,767984,399122,195249,283842,822103,181978,734445,887097,984407,158619,952232,899136,988974,651838,716234,201796,199984,208819,86485,1007824,13505,372049,963030,493278,749999,926165,353845,586236,705483,58445,1038442,555606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]