SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539758 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539758 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379367,297138,453612,557855,17431,1048485,62181,764180,208958,638212,576749,379004,1024230,1034484,600702,233660,184993,229848,197068,948484,576979,813503,618947,917717,767319,123030,751390,237311,489658,211244,712468,840520,435484,9184,26026,303773,872997,339067,807438,917923,672429,26065,122980,899087,623813,463773,1011652,768872,16885,522798,545977,102233,114142,111110,746426,182946,145887,356564,892148,853046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001888s ]